﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Transactions;
using System.Runtime.Serialization;

using Unis.Framework.ORM.Attributes;
using KingRoad.EPM.SafetyManagementEntity.Model;
using KingRoad.EPM.SafetyManagementDAL;
using System.Data;
using Unis.Framework.RuleBase.Common;

namespace ScmCostActualmainService
{    
    /// <summary> 
    /// 文件生成时间 2017/2/13 18:23:57
    /// </summary> 
    public class ScmCostactualmainService :BaseService<ScmCostactualmainInfo>, IScmCostactualmainService
    {
        public DataTable GetCostLedger(DateTime? starttime,DateTime? endtime)
        {
            string param = "";
            if (starttime!=null&&endtime!=null)
            {
                param = " where cam_yearmonth between '" + starttime + "' and '" + endtime+"' ";    
            }
            
            var dt = DatabaseExcuteByXmlHelper.NewInstance.GetDataSetByXml("ScmCostactualmain", "GetCostLedger", param);
            return dt.Tables[0];
        }
        
    }

}

